Here’s the simple N8N automation I built that pulls invoice data from Google Sheets, creates a PDF using Templated.io, emails it to the client, and updates the sheet automatically.
🔗 Useful Links
Templated.io Sign-Up (50 Free Credits): Sign up
Download Workflow JSON:
Code Node JavaScript
// Get invoice number from the Google Sheet node
const invoiceNumber = $('Loop Over Items').first().json['Invoice number'];
for (const item of items) {
if (item.binary && item.binary.data) {
item.binary.data.fileName = `${invoiceNumber}.pdf`;
}
}
return items;
⚙️ Tools Used
- n8n
- Templated.io
- Google Sheets
- Gmail / SMTP
